Problem Note 50221: The field CONTRY_NM in the GEO_UP_DIM table is not populated in SAS® Customer Experience Analytics Server 6.1
 |  |  |  |  |
In SAS Customer Experience Analytics Server 6.1, the COUNTRY_NM field in the GEO_IP_DIM table is not populated with the country name. The field is always empty despite the fact that the source is populated.
As a workaround for this problem, add the following data-cleaning code to the uncompiled macro:
'cxa_clean_geo_ip_dim':
COUNTRY_NM=country_name;
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Customer Experience Analytics | 64-bit Enabled AIX | 6.1 | 6.3 | 9.3 TS1M2 | 9.4 TS1M0 |
| Microsoft® Windows® for x64 | 6.1 | 6.3 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| 64-bit Enabled Solaris | 6.1 | 6.3 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Linux for x64 | 6.1 | 6.3 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Solaris for x64 | 6.1 | 6.3 | 9.3 TS1M2 | 9.4 TS1M0 | ||
A fix for this issue for SAS Customer Experience Analytics Server 6.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K54.html#50221| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2013-09-19 10:08:04 |
| Date Created: | 2013-06-18 13:52:47 |